PATOPOREXPE

"192.168.0.1:sipop"

PATOPOREXPE

Descriptions

DETALLE DEL EXPEDIENTE POR PATOLOGIAS

Fields

Name	Data type	Description
PATOLOGIA	CHAR (2)	ID de la patologia
EXPEDIENTE	CHAR (8)	Expediente registrado
FECH_DIAGNOSTICO	DATE	Fecha del diagnostico
FECH_REGI_PATO	DATE	Fecho de registro en el sistema
NOMB_MEDICO	CHAR (30)	Nombre del medico
INST_REFERENCIA	CHAR (30)	Institucion que lo refiere
PRESCRIPCION	CHAR (240)	Preescripcion dada por el medico
OBSERVACIONES	CHAR (240)	Observaciones del tecnico

Triggers

There are no triggers for table PATOPOREXPE

Indices

Index	Fields	Active	Unique	Order
FK_PATOPOREXPE	PATOLOGIA			Ascending

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
PATOLOGIAS	FK_PATOPOREXPE	PATOLOGIA	ID_PATOLOGIAS	RESTRICT	RESTRICT
EXPEDIENTE	INTEG_274	EXPEDIENTE	ID_EXPEDIENTE	RESTRICT	RESTRICT

Referenced

There are no tables referenced by table PATOPOREXPE

Definition


CREATE TABLE PATOPOREXPE (
    PATOLOGIA CHAR (2) CHARACTER SET NONE COLLATE NONE,
    EXPEDIENTE CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    FECH_DIAGNOSTICO DATE NOT NULL,
    FECH_REGI_PATO DATE NOT NULL,
    NOMB_MEDICO CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    INST_REFERENCIA CHAR (30) CHARACTER SET NONE COLLATE NONE,
    PRESCRIPCION CHAR (240) CHARACTER SET NONE COLLATE NONE,
    OBSERVACIONES CHAR (240) CHARACTER SET NONE COLLATE NONE);

ALTER TABLE PATOPOREXPE ADD CONSTRAINT FK_PATOPOREXPE FOREIGN KEY (PATOLOGIA) REFERENCES PATOLOGIAS (ID_PATOLOGIAS);
ALTER TABLE PATOPOREXPE ADD  FOREIGN KEY (EXPEDIENTE) REFERENCES EXPEDIENTE (ID_EXPEDIENTE);
CREATE INDEX FK_PATOPOREXPE ON PATOPOREXPE (PATOLOGIA);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.